SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 51194: When you use SASINITIALFOLDER options in a SAS® program that resides on the network, you might not be able to connect to the database

DetailsAboutRate It

If the SASINITIALFOLDER option is set to a network path such as -sasinitialfolder \\network\folder, the following error might occur when you connect to an Oracle or Teradata database:

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. 
ERROR: Image SASORA found but not loadable. Please make sure Oracle environment is set correctly.
The error below appears in the log when you try to assign a LIBNAME to Teradata and the SASINITFOLDER option is set to a network drive:
ERROR: The SAS/ACCESS Interface to Teradata cannot be loaded. 
The SASTRA code appendage could not be loaded
An error similar to the one above could occur if the SAS program that is used to connect to a database resides on a network drive and you try to run the program as a batch job. The program runs without any problem if your current directory path is a local drive or you are running in interactive mode.

To resolve the problem, follow these steps:

Warning: Changes in the Windows registry can render your system unusable and require that you reinstall the operating system. Always back up your registry before you make any registry changes. For assistance, see Windows Help, Microsoft documentation, or the Microsoft Windows website. SAS is not responsible when you edit the Windows registry.

  1. Open the Windows Registry Editor:
    1. Select Start ► Run.
    2. Enter regedit in the search box.
  2. Navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\App Paths.
  3. Look for the key SAS.EXE. There are two entries under SAS.EXE. Remove the quotation marks from the beginning and end of the paths for both entries.
  4. Reboot your machine, invoke SAS, and try connecting to your database.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to OracleMicrosoft® Windows® for x649.3_M19.4_M19.3 TS1M19.4 TS1M1
Microsoft Windows Server 2003 Datacenter Edition9.3_M19.3 TS1M1
Microsoft Windows Server 2003 Enterprise Edition9.3_M19.3 TS1M1
Microsoft Windows Server 2003 Standard Edition9.3_M19.3 TS1M1
Microsoft Windows Server 2003 for x649.3_M19.3 TS1M1
Microsoft Windows Server 20089.3_M19.3 TS1M1
Microsoft Windows Server 2008 R29.3_M19.4_M19.3 TS1M19.4 TS1M1
Microsoft Windows Server 2008 for x649.3_M19.4_M19.3 TS1M19.4 TS1M1
Windows 7 Enterprise 32 bit9.3_M19.3 TS1M1
Windows 7 Enterprise x649.3_M19.3 TS1M1
Windows 7 Home Premium 32 bit9.3_M19.3 TS1M1
Windows 7 Home Premium x649.3_M19.3 TS1M1
Windows 7 Professional 32 bit9.3_M19.3 TS1M1
Windows 7 Professional x649.3_M19.4_M19.3 TS1M19.4 TS1M1
Windows 7 Ultimate 32 bit9.3_M19.3 TS1M1
Windows 7 Ultimate x649.3_M19.3 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.